class CreateAppointedOverviews < ActiveRecord::Migration[5.0]
  def change
    create_table :appointed_overviews do |t|
      t.string :report_date, comment: '报表日期'
      t.string :company, comment: '报表集团'
      t.integer :member_type, comment: '新老用户区分'
      t.integer :member_count, comment: '人数'
      t.integer :free_appointed, comment: '免费预约人数'
      t.integer :tuition_appointed, comment: '收费预约人数'
      t.integer :free_course_appointed, comment: '免费课数'
      t.integer :tuition_course_appointed, comment: '收费课数'
      t.integer :free_avg, comment: '免费平均'
      t.integer :tuition_avg, comment: '收费平均'
      t.timestamps
    end
  end
end
